Stored Procedures [dbo].[BAEEventSetupGetQuestionChoice]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@QuestionIDint4
@AnswerIDvarchar(8)8
SQL Script
create procedure [dbo].[BAEEventSetupGetQuestionChoice] @QuestionID int,
     @AnswerID varchar(8) as
SELECT Answer
    FROM EventSetupQuestionChoice
    WHERE EventSetupQuestionChoiceID = @AnswerID AND EventSetupQuestionID = @QuestionID

GO
Uses